package db.tables;

import java.sql.SQLException;

import org.hsqldb.Types;

import db.DBObject;

public class DBCountryTable extends DBObject {

	public static final String TABLE_NAME = "country";

	public static final String COUNTRY_ID_COL = "country_id",
			COUNTRY_SHORT_COL = "country_shortname",
			COUNTRY_NAME_COL = "country_name";
	
	public DBCountryTable() throws ClassNotFoundException, SQLException {
		super(TABLE_NAME,new Object[][]{
			{ COUNTRY_ID_COL, Types.BIGINT, SQL_IDENTITY_PRIMARY_KEY, "" },
			{ COUNTRY_SHORT_COL, Types.VARCHAR, SQL_NOT_NULL, "" },
			{ COUNTRY_NAME_COL, Types.VARCHAR, SQL_NOT_NULL
				+getSQLUnique(COUNTRY_SHORT_COL), "" }});
	}
}
